insert into takes
select id,'CS-001',1,'Fall',2017,NULL from student
where  dept_name='Comp. Sci.';